package zhongbo.java.air.dictionary.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import zhongbo.java.air.dictionary.model.AirCraft;

/**
 * 说明：
 *
 * @author 钟波dellNotebook
 * @since 2025年03月31日 星期一 08:28:27
 */
@Mapper
public interface AirCraftMapper extends BaseMapper<AirCraft> {
    @Select("select * from air_aircraft where icao_code = #{icaoCode}")
    AirCraft selectByIcaoCode(String icaoCode);
    @Select("select * from air_aircraft where registration = #{registration}")
    AirCraft selectByRegistration(String registration);

    AirCraft selectAllAir(String registration);
}
